Pandas Profiling Report

Dataset statistics

Number of variables	16
Number of observations	15288
Missing cells	90
Missing cells (%)	< 0.1%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.7 MiB
Average record size in memory	120.0 B

Variable types

DateTime	1
Numeric	15

Alerts

`avg_flow_rate` is highly overall correlated with `avg_water_level` and 7 other fields	High correlation
`avg_water_level` is highly overall correlated with `avg_flow_rate` and 7 other fields	High correlation
`avg_water_temperature` is highly overall correlated with `max_water_temperature` and 1 other fields	High correlation
`max_flow_rate` is highly overall correlated with `avg_flow_rate` and 7 other fields	High correlation
`max_water_level` is highly overall correlated with `avg_flow_rate` and 7 other fields	High correlation
`max_water_temperature` is highly overall correlated with `avg_water_temperature` and 1 other fields	High correlation
`min_flow_rate` is highly overall correlated with `avg_flow_rate` and 7 other fields	High correlation
`min_water_level` is highly overall correlated with `avg_flow_rate` and 7 other fields	High correlation
`min_water_temperature` is highly overall correlated with `avg_water_temperature` and 1 other fields	High correlation
`suspended_sediment_erosion` is highly overall correlated with `avg_flow_rate` and 8 other fields	High correlation
`suspended_sediment_transport` is highly overall correlated with `avg_flow_rate` and 8 other fields	High correlation
`suspended_solid_load` is highly overall correlated with `avg_flow_rate` and 8 other fields	High correlation
`suspended_solids_concentration` is highly overall correlated with `suspended_sediment_erosion` and 2 other fields	High correlation
`date` has unique values	Unique
`suspended_sediment_erosion` has 1887 (12.3%) zeros	Zeros

Reproduction

Analysis started	2024-09-14 08:15:50.854025
Analysis finished	2024-09-14 08:16:34.969974
Duration	44.12 seconds
Software version	ydata-profiling vv4.9.0
Download configuration	config.json

date
Date

UNIQUE

Distinct	15288
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	119.6 KiB

Minimum	1980-11-01 00:00:00
Maximum	2024-08-31 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

avg_water_temperature
Real number (ℝ)

HIGH CORRELATION

Distinct	216
Distinct (%)	1.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9.9120552

Minimum	0.2
Maximum	21.8
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	119.6 KiB

Quantile statistics

Minimum	0.2
5-th percentile	3.2
Q1	5.5
median	9.6
Q3	14.1
95-th percentile	17.6
Maximum	21.8
Range	21.6
Interquartile range (IQR)	8.6

Descriptive statistics

Standard deviation	4.8306741
Coefficient of variation (CV)	0.48735343
Kurtosis	-1.1573734
Mean	9.9120552
Median Absolute Deviation (MAD)	4.3
Skewness	0.17908716
Sum	151535.5
Variance	23.335412
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4.2	221	1.4%
5	193	1.3%
4	173	1.1%
4.8	168	1.1%
5.2	168	1.1%
4.4	166	1.1%
5.8	161	1.1%
4.6	160	1.0%
3.8	153	1.0%
6.2	149	1.0%
Other values (206)	13576	88.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.2	1	< 0.1%
0.3	3	< 0.1%
0.4	2	< 0.1%
0.6	1	< 0.1%
0.7	1	< 0.1%
0.8	6	< 0.1%
0.9	6	< 0.1%
1	10	0.1%
1.1	9	0.1%
1.2	11	0.1%

Value	Count	Frequency (%)
21.8	1	< 0.1%
21.7	3	< 0.1%
21.6	1	< 0.1%
21.5	3	< 0.1%
21.4	3	< 0.1%
21.3	1	< 0.1%
21.2	6	< 0.1%
21.1	5	< 0.1%
21	4	< 0.1%
20.9	3	< 0.1%

max_water_temperature
Real number (ℝ)

HIGH CORRELATION

Distinct	220
Distinct (%)	1.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	10.198947

Minimum	0.5
Maximum	22.4
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	119.6 KiB

Quantile statistics

Minimum	0.5
5-th percentile	3.3
Q1	5.7
median	9.9
Q3	14.3
95-th percentile	18.2
Maximum	22.4
Range	21.9
Interquartile range (IQR)	8.6

Descriptive statistics

Standard deviation	4.955
Coefficient of variation (CV)	0.48583448
Kurtosis	-1.1250851
Mean	10.198947
Median Absolute Deviation (MAD)	4.3
Skewness	0.19928398
Sum	155921.5
Variance	24.552025
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4.2	209	1.4%
4.8	192	1.3%
5	191	1.2%
5.2	180	1.2%
4.4	165	1.1%
5.8	164	1.1%
6	164	1.1%
6.2	159	1.0%
4.6	159	1.0%
4	155	1.0%
Other values (210)	13550	88.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.5	3	< 0.1%
0.6	1	< 0.1%
0.7	1	< 0.1%
0.8	4	< 0.1%
0.9	1	< 0.1%
1	8	0.1%
1.1	6	< 0.1%
1.2	11	0.1%
1.3	4	< 0.1%
1.4	13	0.1%

Value	Count	Frequency (%)
22.4	1	< 0.1%
22.3	2	< 0.1%
22.2	2	< 0.1%
22.1	2	< 0.1%
22	2	< 0.1%
21.9	2	< 0.1%
21.8	3	< 0.1%
21.7	4	< 0.1%
21.6	4	< 0.1%
21.5	6	< 0.1%

min_water_temperature
Real number (ℝ)

HIGH CORRELATION

Distinct	213
Distinct (%)	1.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9.6312794

Minimum	-0.1
Maximum	21.4
Zeros	0
Zeros (%)	0.0%
Negative	2
Negative (%)	< 0.1%
Memory size	119.6 KiB

Quantile statistics

Minimum	-0.1
5-th percentile	3
Q1	5.3
median	9.3
Q3	13.8
95-th percentile	17.1
Maximum	21.4
Range	21.5
Interquartile range (IQR)	8.5

Descriptive statistics

Standard deviation	4.7329891
Coefficient of variation (CV)	0.49141852
Kurtosis	-1.1660593
Mean	9.6312794
Median Absolute Deviation (MAD)	4.2
Skewness	0.17200289
Sum	147243
Variance	22.401185
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4.2	230	1.5%
4	190	1.2%
5	190	1.2%
4.8	177	1.2%
3.8	171	1.1%
14.8	166	1.1%
4.4	164	1.1%
5.2	160	1.0%
5.6	157	1.0%
6	155	1.0%
Other values (203)	13528	88.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-0.1	2	< 0.1%
0.1	2	< 0.1%
0.2	3	< 0.1%
0.3	1	< 0.1%
0.4	2	< 0.1%
0.5	4	< 0.1%
0.6	5	< 0.1%
0.7	3	< 0.1%
0.8	6	< 0.1%
0.9	6	< 0.1%

Value	Count	Frequency (%)
21.4	3	< 0.1%
21.2	6	< 0.1%
21.1	1	< 0.1%
21	4	< 0.1%
20.9	2	< 0.1%
20.8	2	< 0.1%
20.6	5	< 0.1%
20.5	4	< 0.1%
20.4	8	0.1%
20.3	3	< 0.1%

avg_water_level
Real number (ℝ)

HIGH CORRELATION

Distinct	274
Distinct (%)	1.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	84.137232

Minimum	19
Maximum	495
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	119.6 KiB

Quantile statistics

Minimum	19
5-th percentile	42
Q1	59
median	78
Q3	99
95-th percentile	148
Maximum	495
Range	476
Interquartile range (IQR)	40

Descriptive statistics

Standard deviation	35.951824
Coefficient of variation (CV)	0.42729982
Kurtosis	9.6487635
Mean	84.137232
Median Absolute Deviation (MAD)	20
Skewness	2.0809083
Sum	1286290
Variance	1292.5337
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
75	233	1.5%
59	233	1.5%
72	228	1.5%
74	224	1.5%
55	220	1.4%
58	220	1.4%
54	220	1.4%
79	217	1.4%
77	216	1.4%
61	216	1.4%
Other values (264)	13061	85.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
19	1	< 0.1%
22	1	< 0.1%
24	1	< 0.1%
25	1	< 0.1%
27	9	0.1%
28	7	< 0.1%
29	11	0.1%
30	12	0.1%
31	7	< 0.1%
32	15	0.1%

Value	Count	Frequency (%)
495	1	< 0.1%
450	1	< 0.1%
442	1	< 0.1%
432	1	< 0.1%
430	1	< 0.1%
414	1	< 0.1%
389	1	< 0.1%
387	2	< 0.1%
376	1	< 0.1%
350	1	< 0.1%

max_water_level
Real number (ℝ)

HIGH CORRELATION

Distinct	293
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	93.129579

Minimum	25
Maximum	542
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	119.6 KiB

Quantile statistics

Minimum	25
5-th percentile	48
Q1	68
median	86
Q3	108
95-th percentile	165
Maximum	542
Range	517
Interquartile range (IQR)	40

Descriptive statistics

Standard deviation	39.541371
Coefficient of variation (CV)	0.42458445
Kurtosis	9.9670938
Mean	93.129579
Median Absolute Deviation (MAD)	20
Skewness	2.1978506
Sum	1423765
Variance	1563.52
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
80	248	1.6%
82	243	1.6%
84	234	1.5%
85	230	1.5%
88	225	1.5%
70	224	1.5%
90	218	1.4%
87	214	1.4%
74	213	1.4%
78	212	1.4%
Other values (283)	13027	85.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
25	1	< 0.1%
28	6	< 0.1%
29	3	< 0.1%
30	4	< 0.1%
31	9	0.1%
32	7	< 0.1%
33	17	0.1%
34	18	0.1%
35	26	0.2%
36	39	0.3%

Value	Count	Frequency (%)
542	1	< 0.1%
491	1	< 0.1%
469	1	< 0.1%
467	1	< 0.1%
453	1	< 0.1%
439	1	< 0.1%
436	1	< 0.1%
424	1	< 0.1%
414	1	< 0.1%
395	1	< 0.1%

min_water_level
Real number (ℝ)

HIGH CORRELATION

Distinct	249
Distinct (%)	1.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	75.599359

Minimum	11
Maximum	451
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	119.6 KiB

Quantile statistics

Minimum	11
5-th percentile	37
Q1	52
median	70
Q3	91
95-th percentile	135
Maximum	451
Range	440
Interquartile range (IQR)	39

Descriptive statistics

Standard deviation	33.177899
Coefficient of variation (CV)	0.43886483
Kurtosis	9.1020026
Mean	75.599359
Median Absolute Deviation (MAD)	19
Skewness	1.9709382
Sum	1155763
Variance	1100.773
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
52	272	1.8%
48	266	1.7%
47	265	1.7%
46	264	1.7%
53	248	1.6%
49	247	1.6%
51	247	1.6%
56	246	1.6%
54	240	1.6%
50	236	1.5%
Other values (239)	12757	83.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
11	1	< 0.1%
13	1	< 0.1%
15	1	< 0.1%
16	1	< 0.1%
17	1	< 0.1%
19	3	< 0.1%
20	3	< 0.1%
21	1	< 0.1%
22	3	< 0.1%
23	7	< 0.1%

Value	Count	Frequency (%)
451	1	< 0.1%
434	1	< 0.1%
425	1	< 0.1%
413	1	< 0.1%
389	1	< 0.1%
382	1	< 0.1%
358	1	< 0.1%
334	1	< 0.1%
326	1	< 0.1%
317	1	< 0.1%

suspended_solids_concentration
Real number (ℝ)

HIGH CORRELATION

Distinct	4082
Distinct (%)	26.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	21.659735

Minimum	1.05
Maximum	2000.97
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	119.6 KiB

Quantile statistics

Minimum	1.05
5-th percentile	2.56
Q1	6.66
median	10.82
Q3	17.75
95-th percentile	55.1255
Maximum	2000.97
Range	1999.92
Interquartile range (IQR)	11.09

Descriptive statistics

Standard deviation	74.59221
Coefficient of variation (CV)	3.4438191
Kurtosis	446.58769
Mean	21.659735
Median Absolute Deviation (MAD)	4.98
Skewness	18.621017
Sum	331134.03
Variance	5563.9979
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6	44	0.3%
4.44	25	0.2%
12	22	0.1%
7	22	0.1%
9.96	21	0.1%
8.43	20	0.1%
7.05	20	0.1%
8	19	0.1%
7.62	18	0.1%
6.37	18	0.1%
Other values (4072)	15059	98.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.05	1	< 0.1%
1.06	2	< 0.1%
1.07	3	< 0.1%
1.08	4	< 0.1%
1.09	5	< 0.1%
1.1	5	< 0.1%
1.11	7	< 0.1%
1.12	10	0.1%
1.13	12	0.1%
1.14	12	0.1%

Value	Count	Frequency (%)
2000.97	1	< 0.1%
2000.86	1	< 0.1%
2000.84	1	< 0.1%
2000.78	1	< 0.1%
2000.71	2	< 0.1%
2000.53	1	< 0.1%
2000.51	1	< 0.1%
2000.49	1	< 0.1%
2000.45	1	< 0.1%
2000.42	1	< 0.1%

suspended_solid_load
Real number (ℝ)

HIGH CORRELATION

Distinct	9686
Distinct (%)	63.5%
Missing	30
Missing (%)	0.2%
Infinite	0
Infinite (%)	0.0%
Mean	231.56506

Minimum	1.49
Maximum	50194.83
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	119.6 KiB

Quantile statistics

Minimum	1.49
5-th percentile	7.4085
Q1	21.4525
median	43.35
Q3	98.615
95-th percentile	627.2245
Maximum	50194.83
Range	50193.34
Interquartile range (IQR)	77.1625

Descriptive statistics

Standard deviation	1305.0911
Coefficient of variation (CV)	5.6359587
Kurtosis	558.19931
Mean	231.56506
Median Absolute Deviation (MAD)	27.7
Skewness	19.629288
Sum	3533219.7
Variance	1703262.8
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
22.19	9	0.1%
18.53	8	0.1%
15.98	8	0.1%
13.67	7	< 0.1%
9.44	7	< 0.1%
12.07	7	< 0.1%
28.72	7	< 0.1%
27.33	7	< 0.1%
18.38	7	< 0.1%
32.38	7	< 0.1%
Other values (9676)	15184	99.3%
(Missing)	30	0.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.49	1	< 0.1%
1.59	1	< 0.1%
1.73	1	< 0.1%
1.76	1	< 0.1%
1.87	1	< 0.1%
1.89	1	< 0.1%
1.97	2	< 0.1%
2	1	< 0.1%
2.04	1	< 0.1%
2.14	1	< 0.1%

Value	Count	Frequency (%)
50194.83	1	< 0.1%
49272.42	1	< 0.1%
48842.49	1	< 0.1%
37524.15	1	< 0.1%
34556.33	1	< 0.1%
29134.88	1	< 0.1%
24136.73	1	< 0.1%
23866.37	1	< 0.1%
23374.05	1	< 0.1%
23291.65	1	< 0.1%

suspended_sediment_erosion
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	255
Distinct (%)	1.7%
Missing	30
Missing (%)	0.2%
Infinite	0
Infinite (%)	0.0%
Mean	0.082023201

Minimum	0
Maximum	17.68
Zeros	1887
Zeros (%)	12.3%
Negative	0
Negative (%)	0.0%
Memory size	119.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.01
median	0.02
Q3	0.04
95-th percentile	0.22
Maximum	17.68
Range	17.68
Interquartile range (IQR)	0.03

Descriptive statistics

Standard deviation	0.45983058
Coefficient of variation (CV)	5.6061039
Kurtosis	558.04382
Mean	0.082023201
Median Absolute Deviation (MAD)	0.01
Skewness	19.626501
Sum	1251.51
Variance	0.21144417
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.01	5421	35.5%
0.02	2717	17.8%
0	1887	12.3%
0.03	1383	9.0%
0.04	805	5.3%
0.05	531	3.5%
0.06	334	2.2%
0.07	270	1.8%
0.08	195	1.3%
0.09	159	1.0%
Other values (245)	1556	10.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1887	12.3%
0.01	5421	35.5%
0.02	2717	17.8%
0.03	1383	9.0%
0.04	805	5.3%
0.05	531	3.5%
0.06	334	2.2%
0.07	270	1.8%
0.08	195	1.3%
0.09	159	1.0%

Value	Count	Frequency (%)
17.68	1	< 0.1%
17.36	1	< 0.1%
17.21	1	< 0.1%
13.22	1	< 0.1%
12.18	1	< 0.1%
10.27	1	< 0.1%
8.5	1	< 0.1%
8.41	1	< 0.1%
8.24	1	< 0.1%
8.21	1	< 0.1%

suspended_sediment_transport
Real number (ℝ)

HIGH CORRELATION

Distinct	1311
Distinct (%)	8.6%
Missing	30
Missing (%)	0.2%
Infinite	0
Infinite (%)	0.0%
Mean	2.6806816

Minimum	0.02
Maximum	580.96
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	119.6 KiB

Quantile statistics

Minimum	0.02
5-th percentile	0.09
Q1	0.25
median	0.5
Q3	1.14
95-th percentile	7.2615
Maximum	580.96
Range	580.94
Interquartile range (IQR)	0.89

Descriptive statistics

Standard deviation	15.105184
Coefficient of variation (CV)	5.6348297
Kurtosis	558.20567
Mean	2.6806816
Median Absolute Deviation (MAD)	0.32
Skewness	19.629411
Sum	40901.84
Variance	228.16659
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.19	224	1.5%
0.14	222	1.5%
0.22	213	1.4%
0.17	204	1.3%
0.21	203	1.3%
0.28	200	1.3%
0.26	194	1.3%
0.2	190	1.2%
0.3	189	1.2%
0.23	189	1.2%
Other values (1301)	13230	86.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.02	10	0.1%
0.03	22	0.1%
0.04	85	0.6%
0.05	157	1.0%
0.06	166	1.1%
0.07	162	1.1%
0.08	147	1.0%
0.09	165	1.1%
0.1	161	1.1%
0.11	182	1.2%

Value	Count	Frequency (%)
580.96	1	< 0.1%
570.28	1	< 0.1%
565.31	1	< 0.1%
434.31	1	< 0.1%
399.96	1	< 0.1%
337.21	1	< 0.1%
279.36	1	< 0.1%
276.23	1	< 0.1%
270.53	1	< 0.1%
269.58	1	< 0.1%

avg_flow_rate
Real number (ℝ)

HIGH CORRELATION

Distinct	1124
Distinct (%)	7.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	62.588125

Minimum	9.06
Maximum	926
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	119.6 KiB

Quantile statistics

Minimum	9.06
5-th percentile	20.3
Q1	32.1
median	49.9
Q3	76
95-th percentile	148
Maximum	926
Range	916.94
Interquartile range (IQR)	43.9

Descriptive statistics

Standard deviation	49.507343
Coefficient of variation (CV)	0.79100217
Kurtosis	32.11535
Mean	62.588125
Median Absolute Deviation (MAD)	20.5
Skewness	3.9606795
Sum	956847.26
Variance	2450.977
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
104	50	0.3%
102	47	0.3%
101	47	0.3%
107	46	0.3%
105	45	0.3%
103	45	0.3%
109	42	0.3%
106	41	0.3%
26	41	0.3%
33.3	40	0.3%
Other values (1114)	14844	97.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
9.06	1	< 0.1%
10.5	1	< 0.1%
11.5	1	< 0.1%
11.7	1	< 0.1%
13	1	< 0.1%
13.3	1	< 0.1%
13.6	1	< 0.1%
13.7	1	< 0.1%
13.9	3	< 0.1%
14.1	1	< 0.1%

Value	Count	Frequency (%)
926	1	< 0.1%
786	1	< 0.1%
767	1	< 0.1%
757	1	< 0.1%
747	1	< 0.1%
707	1	< 0.1%
648	1	< 0.1%
627	1	< 0.1%
591	1	< 0.1%
561	1	< 0.1%

max_flow_rate
Real number (ℝ)

HIGH CORRELATION

Distinct	1160
Distinct (%)	7.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	73.736787

Minimum	11.8
Maximum	1050
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	119.6 KiB

Quantile statistics

Minimum	11.8
5-th percentile	23.1
Q1	39.575
median	58.7
Q3	87.6
95-th percentile	176
Maximum	1050
Range	1038.2
Interquartile range (IQR)	48.025

Descriptive statistics

Standard deviation	58.349596
Coefficient of variation (CV)	0.79132273
Kurtosis	28.590848
Mean	73.736787
Median Absolute Deviation (MAD)	22.5
Skewness	3.8499989
Sum	1127288
Variance	3404.6753
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
107	74	0.5%
101	67	0.4%
102	66	0.4%
103	62	0.4%
105	61	0.4%
106	59	0.4%
111	57	0.4%
113	52	0.3%
108	52	0.3%
110	51	0.3%
Other values (1150)	14687	96.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
11.8	1	< 0.1%
14.5	1	< 0.1%
14.7	2	< 0.1%
14.8	1	< 0.1%
14.9	1	< 0.1%
15	2	< 0.1%
15.1	5	< 0.1%
15.2	4	< 0.1%
15.3	4	< 0.1%
15.4	2	< 0.1%

Value	Count	Frequency (%)
1050	1	< 0.1%
912	1	< 0.1%
830	1	< 0.1%
827	1	< 0.1%
814	1	< 0.1%
766	1	< 0.1%
758	1	< 0.1%
715	1	< 0.1%
701	1	< 0.1%
653	1	< 0.1%

min_flow_rate
Real number (ℝ)

HIGH CORRELATION

Distinct	1108
Distinct (%)	7.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	52.483891

Minimum	6.02
Maximum	809
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	119.6 KiB

Quantile statistics

Minimum	6.02
5-th percentile	17.7
Q1	25.8
median	40.8
Q3	65
95-th percentile	124
Maximum	809
Range	802.98
Interquartile range (IQR)	39.2

Descriptive statistics

Standard deviation	42.273196
Coefficient of variation (CV)	0.80545089
Kurtosis	36.622683
Mean	52.483891
Median Absolute Deviation (MAD)	17.2
Skewness	4.1183298
Sum	802373.72
Variance	1787.0231
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
23	65	0.4%
25.5	53	0.3%
23.6	53	0.3%
24.3	52	0.3%
25	52	0.3%
22.8	51	0.3%
22.1	48	0.3%
21.3	47	0.3%
19.1	47	0.3%
20.1	47	0.3%
Other values (1098)	14773	96.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
6.02	1	< 0.1%
6.49	1	< 0.1%
7.62	1	< 0.1%
7.66	1	< 0.1%
8.07	1	< 0.1%
8.65	1	< 0.1%
8.85	1	< 0.1%
8.9	1	< 0.1%
9.14	1	< 0.1%
9.15	1	< 0.1%

Value	Count	Frequency (%)
809	1	< 0.1%
751	1	< 0.1%
733	1	< 0.1%
713	1	< 0.1%
649	1	< 0.1%
564	1	< 0.1%
521	1	< 0.1%
505	1	< 0.1%
477	2	< 0.1%
475	1	< 0.1%

year
Real number (ℝ)

Distinct	44
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2001.4394

Minimum	1980
Maximum	2024
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	59.8 KiB

Quantile statistics

Minimum	1980
5-th percentile	1982
Q1	1991
median	2001
Q3	2012
95-th percentile	2022
Maximum	2024
Range	44
Interquartile range (IQR)	21

Descriptive statistics

Standard deviation	12.349482
Coefficient of variation (CV)	0.0061703002
Kurtosis	-1.1478865
Mean	2001.4394
Median Absolute Deviation (MAD)	10
Skewness	0.054458471
Sum	30598006
Variance	152.50971
Monotonicity	Increasing

Histogram with fixed size bins (bins=44)

Value	Count	Frequency (%)
2000	366	2.4%
1992	366	2.4%
2004	366	2.4%
1984	366	2.4%
2016	366	2.4%
1996	366	2.4%
1988	366	2.4%
2008	366	2.4%
2003	365	2.4%
2005	365	2.4%
Other values (34)	11630	76.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1980	61	0.4%
1981	365	2.4%
1982	365	2.4%
1983	365	2.4%
1984	366	2.4%
1985	365	2.4%
1986	365	2.4%
1987	365	2.4%
1988	366	2.4%
1989	365	2.4%

Value	Count	Frequency (%)
2024	244	1.6%
2023	365	2.4%
2022	166	1.1%
2020	360	2.4%
2019	365	2.4%
2018	365	2.4%
2017	361	2.4%
2016	366	2.4%
2015	365	2.4%
2014	365	2.4%

month
Real number (ℝ)

Distinct	12
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.5367609

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	59.8 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	4
median	7
Q3	10
95-th percentile	12
Maximum	12
Range	11
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.4623576
Coefficient of variation (CV)	0.52967482
Kurtosis	-1.2164894
Mean	6.5367609
Median Absolute Deviation (MAD)	3
Skewness	-0.010125007
Sum	99934
Variance	11.98792
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
12	1332	8.7%
8	1305	8.5%
3	1301	8.5%
1	1297	8.5%
11	1289	8.4%
7	1286	8.4%
5	1285	8.4%
10	1277	8.4%
4	1258	8.2%
6	1237	8.1%
Other values (2)	2421	15.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1297	8.5%
2	1187	7.8%
3	1301	8.5%
4	1258	8.2%
5	1285	8.4%
6	1237	8.1%
7	1286	8.4%
8	1305	8.5%
9	1234	8.1%
10	1277	8.4%

Value	Count	Frequency (%)
12	1332	8.7%
11	1289	8.4%
10	1277	8.4%
9	1234	8.1%
8	1305	8.5%
7	1286	8.4%
6	1237	8.1%
5	1285	8.4%
4	1258	8.2%
3	1301	8.5%

Auto

Heatmap
Table

	avg_flow_rate	avg_water_level	avg_water_temperature	max_flow_rate	max_water_level	max_water_temperature	min_flow_rate	min_water_level	min_water_temperature	month	suspended_sediment_erosion	suspended_sediment_transport	suspended_solid_load	suspended_solids_concentration	year
avg_flow_rate	1.000	0.926	0.283	0.984	0.926	0.286	0.976	0.882	0.280	-0.001	0.740	0.752	0.752	0.416	0.005
avg_water_level	0.926	1.000	0.303	0.898	0.981	0.309	0.920	0.977	0.295	0.010	0.655	0.666	0.666	0.343	0.173
avg_water_temperature	0.283	0.303	1.000	0.294	0.318	0.997	0.267	0.281	0.997	0.350	0.223	0.227	0.227	0.109	0.090
max_flow_rate	0.984	0.898	0.294	1.000	0.931	0.295	0.937	0.834	0.293	0.002	0.744	0.755	0.755	0.429	-0.036
max_water_level	0.926	0.981	0.318	0.931	1.000	0.322	0.895	0.934	0.313	0.015	0.671	0.681	0.681	0.363	0.113
max_water_temperature	0.286	0.309	0.997	0.295	0.322	1.000	0.272	0.291	0.989	0.339	0.226	0.231	0.231	0.112	0.140
min_flow_rate	0.976	0.920	0.267	0.937	0.895	0.272	1.000	0.921	0.261	-0.005	0.709	0.722	0.722	0.386	0.054
min_water_level	0.882	0.977	0.281	0.834	0.934	0.291	0.921	1.000	0.269	0.005	0.614	0.624	0.624	0.309	0.239
min_water_temperature	0.280	0.295	0.997	0.293	0.313	0.989	0.261	0.269	1.000	0.360	0.219	0.224	0.224	0.107	0.037
month	-0.001	0.010	0.350	0.002	0.015	0.339	-0.005	0.005	0.360	1.000	-0.041	-0.040	-0.040	-0.066	-0.012
suspended_sediment_erosion	0.740	0.655	0.223	0.744	0.671	0.226	0.709	0.614	0.219	-0.041	1.000	0.973	0.973	0.860	-0.024
suspended_sediment_transport	0.752	0.666	0.227	0.755	0.681	0.231	0.722	0.624	0.224	-0.040	0.973	1.000	1.000	0.880	-0.022
suspended_solid_load	0.752	0.666	0.227	0.755	0.681	0.231	0.722	0.624	0.224	-0.040	0.973	1.000	1.000	0.880	-0.022
suspended_solids_concentration	0.416	0.343	0.109	0.429	0.363	0.112	0.386	0.309	0.107	-0.066	0.860	0.880	0.880	1.000	-0.056
year	0.005	0.173	0.090	-0.036	0.113	0.140	0.054	0.239	0.037	-0.012	-0.024	-0.022	-0.022	-0.056	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	date	avg_water_temperature	max_water_temperature	min_water_temperature	avg_water_level	max_water_level	min_water_level	suspended_solids_concentration	suspended_solid_load	suspended_sediment_erosion	suspended_sediment_transport	avg_flow_rate	max_flow_rate	min_flow_rate	year	month
0	1980-11-01	8.1	8.1	8.1	71	86	59	5.57	25.56	0.01	0.30	47.9	63.4	37.0	1980	11
1	1980-11-02	7.3	7.3	7.3	59	62	54	5.10	21.54	0.01	0.25	36.7	39.6	32.7	1980	11
2	1980-11-03	5.8	5.8	5.8	68	83	48	5.14	20.16	0.01	0.23	45.8	60.0	27.9	1980	11
3	1980-11-04	5.6	5.6	5.6	77	80	73	7.60	31.26	0.01	0.36	53.4	56.9	49.9	1980	11
4	1980-11-05	4.8	4.8	4.8	77	89	70	9.03	37.83	0.01	0.44	54.1	66.5	47.0	1980	11
5	1980-11-06	4.7	4.7	4.7	75	82	64	5.59	22.19	0.01	0.26	51.4	58.8	41.3	1980	11
6	1980-11-07	6.1	6.1	6.1	62	72	44	4.58	16.04	0.01	0.19	39.4	48.8	24.8	1980	11
7	1980-11-08	7.7	7.7	7.7	56	65	43	11.34	40.00	0.01	0.46	34.5	42.2	24.0	1980	11
8	1980-11-09	7.5	7.5	7.5	55	64	43	13.53	42.45	0.02	0.49	33.3	41.2	24.0	1980	11
9	1980-11-10	7.6	7.6	7.6	48	60	40	15.29	42.92	0.02	0.50	27.8	37.6	21.8	1980	11

	date	avg_water_temperature	max_water_temperature	min_water_temperature	avg_water_level	max_water_level	min_water_level	suspended_solids_concentration	suspended_solid_load	suspended_sediment_erosion	suspended_sediment_transport	avg_flow_rate	max_flow_rate	min_flow_rate	year	month
15278	2024-08-22	17.6	18.4	16.7	131	136	125	34.95	NaN	NaN	NaN	68.0	75.2	58.8	2024	8
15279	2024-08-23	18.0	19.1	16.9	127	130	121	34.95	NaN	NaN	NaN	61.8	66.2	53.0	2024	8
15280	2024-08-24	18.8	20.0	17.6	126	131	120	34.95	NaN	NaN	NaN	60.5	67.7	51.6	2024	8
15281	2024-08-25	18.3	19.7	17.5	121	144	111	34.95	NaN	NaN	NaN	52.7	87.5	39.7	2024	8
15282	2024-08-26	16.4	17.4	16.1	142	150	131	34.95	NaN	NaN	NaN	84.2	96.9	67.7	2024	8
15283	2024-08-27	16.6	17.6	15.8	130	137	121	34.95	NaN	NaN	NaN	66.0	76.7	53.0	2024	8
15284	2024-08-28	17.8	19.0	16.6	117	121	113	34.95	NaN	NaN	NaN	47.5	53.0	42.2	2024	8
15285	2024-08-29	18.7	19.6	17.7	114	116	110	34.95	NaN	NaN	NaN	43.2	46.1	38.5	2024	8
15286	2024-08-30	19.1	19.8	18.1	114	116	108	34.95	NaN	NaN	NaN	43.5	46.1	36.3	2024	8
15287	2024-08-31	19.1	19.7	18.2	109	115	104	34.95	NaN	NaN	NaN	37.7	44.8	32.0	2024	8

Overview

Variables

Interactions

Correlations

Missing values

Sample